<?php
	/* Template Name: Full Product List*/ 
?>

<?php get_header() ?>

	<div id="container">
    
    	<?php include('breadcrumbs.php'); ?>
    
    	<?php get_sidebar() ?>
    
		<div id="content">

<?php the_post() ?>

			<div id="post-<?php the_ID() ?>" class="<?php sandbox_post_class() ?>">
			<h2 class="entry-title"><?php the_title() ?></h2>
                <?php include ('socialbuttons.php'); ?>
				<div class="entry-content">
                                    
                                    <table>
                                        <tr>
                                            <td>ID</td>
                                            <td>SKU</td>
                                        </tr>
                                    <?php
$args = array('post_type' => 'product', 'posts_per_page' => '-1');
   $pricelist = new WP_Query($args);

   if($pricelist->have_posts()) : 
      while($pricelist->have_posts()) : 
         $pricelist->the_post(); 
   
        $productid = get_the_ID();
        $productsku = get_post_meta($post->ID, '_sku', true);
   
   ?>
   
                                        <tr>
                                            <td><?php echo $productid ; ?></td>
                                            <td><?php echo $productsku ; ?></td>
                                        </tr>                           

                                    
 <?php endwhile; ?>
<?php endif; ?>
                                </div>

			</div><!-- .post -->

<?php if ( get_post_custom_values('comments') ) comments_template() // Add a key+value of "comments" to enable comments on this page ?>

		</div><!-- #content -->
	</div><!-- #container -->

<?php get_footer() ?>